Commercial Transactions

1. In the Modules Tasks pane, select the Forecasts optManagemention in the FX folder of the module.

The modification page of the default filter for this function, is displayed.

This page enables you to define filtering criteria restricting or enlarging the selection of transactions to display in the page for Commercial Transactions. If no filter is defined here, all the existing commercial transactions are displayed on the page. If the number of transactions is too large, restricting the selection improves the legibility.

2. Set up the filter, then click OK.

The management page for Commercial Transactions is displayed with the list of the created transactions in a table.

This table displays the list of the commercial transactions as well as their types, their numbers, the transaction and delivery dates, their companies, their amounts, their countervalues, the non-hedged amounts, the indicators for hedging modification, the budget and market exchange rates, the budget codes, the related bank accounts, the third parties, the transaction statuses (open, settled, updated), their origins (internal or external), the reference numbers and the link numbers if any, as well as potential notes.

For more information on:

• reorganizing the lines in the table, click here
• how to search text in the table, click here
• how to create lines, see the topic below
• modifying lines in the table, click here
• deleting lines in the table, click here

You can change the layout of the table: selecting columns, filtering displayed information, grouping lines according to data, etc. For more information on this feature, see topic Table Reorganization.

1. In the management page for Commercial Transactions, click the Create button.

The creation page is displayed.

The header presents the basic information of the transaction.

2. Complete the fields of the header.

In the following table, the green ticks in the M column indicate that the fields are mandatory.

The red crosses in the E column indicate the fields that cannot be modified after the transaction record.

View Header Description

Field	Description	M	E
Receipt/Disbursement	Define the direction of your transaction by enabling the Receipt or Disbursement options. Note: The transaction direction is the direction of the currency next to the Amount field against the local currency (company currency).
Transaction	This field enables you to select a type of transaction according to the defined transaction direction. Click the button to view the list of the existing transaction types then, in the contextual window, double-click a line to select it. The code and description of the selected transaction type, are displayed in the Transaction field.
No.	This non-editable field displays the transaction identifier. You cannot enter any information in this field. It is blank during the creation and then automatically completed when the transaction is saved.
Link No.	This optional field enables the grouping of commercial transactions and FX transactions together, under a common link number. This number shows the assigned category (activity type, geographical area, project, etc.). It can then be used as a criterion of accounting or filtering processing. For more information on link numbers, see Setup documentation. To select a link number, use the button as explained previously.
Status	This non-editable field shows the transaction settlement status: open or closed.

The Characteristics tab enables you to define the main information on the transaction to create.

3. Complete the fields of the tab.

In the following table, the green ticks in the M column indicate that the fields are mandatory.

The red crosses in the E column indicate the fields that cannot be modified once the transaction is saved.

View Fields Description

Field	Description	M	E
General area
Company	This field enables you to select the company associated with the transaction. To select a company, use the button as described previously. The fields for the Countervalue Currency, the Budget and Opportunity Rates are automatically completed on the basis of the selected company.
Amount	These fields display the main currency and the transaction amount expressed in the main currency. Select the main currency using the button as described previously. The currency code is displayed in the first field. In the adjacent field, enter the transaction amount expressed in the main currency or calculate this amount using the calculator. For more information on how to use the calculator, click here. Once the transaction amount and main currency are completed, the amount in position and the countervalue amount are automatically calculated and displayed. If the company was also entered, the values for the budget and opportunity rates are then automatically completed based on the transaction currency and the company.
In position	This field shows the position of the transaction balance after partial or total update. This area which is automatically completed on the basis of the transaction amount, cannot be modified. For each partial update, the amount paid is deducted from the position. For more information on the Update, see topic Update.
Countervalue	These fields show the countervalue currency and the transaction amount expressed in the countervalue currency. The countervalue amount is automatically completed on the basis of the budget exchange rate and the transaction amount. The default countervalue currency corresponds to the local currency of the company associated with the transaction.		(currency)
TRX Date	This field displays the date when the commercial transaction is performed. The default value for this field is today's date. To change this date, enter a date in the field or use the calendar. For more information on how to use the calendar, click here.
Delivery Date	This field displays the maturity date of the commercial transaction. The default value for this field is today's date. It can be replaced by an identical date or a date falling after the transaction date. To change this value, enter a date in the field or use the calendar.
Rate area This area displays the values of the budget and opportunity rates.
Budget Rate	This field displays the budget exchange rate for the currencies of the transaction. This field enables the budgeting of commercial transactions. Once the company and transaction currencies are entered, this field is completed based on the setup defined in Market Data. This value can be modified. This field displays the budget rate valid on the delivery month, as opposed to the rate of the transaction date month. If you did not define any budget rate for the selected currency pair and period, you now need to enter a value in this field, so that the countervalue amount can be calculated.
Opportunity Rate	This field displays the market exchange rate for the commercial transaction currencies. It enables the comparison between the performance of a hedging stategy and the performance of a non-hedging strategy. This field is completed on the basis of the setup defined in Market Data. It can be modified. This is the forward exchange rate at maturity of the transaction, as on the transaction date.
Account	This field displays the bank account associated with the commercial transaction. This field only appears in the Detailed, Reconciliation Mode. The Accounts and Flow Code areas indicate that the commercial transactions entered in the FX module are considered in Cash as forecasts on these accounts, with the same codes.
Flow Code	This field displays the type of cash flow linked to the transaction. This field only appears in the Detailed, Reconciliation Mode.
Conversion	This function enables you to calculate the countervalue of the transaction amount expressed in the bank account currency. This button only appears in the Detailed, Reconciliation Mode.
Conversion Amount	This field displays the countervalue of the transaction amount expressed in the bank account currency. This field only appears in the Detailed, Reconciliation Mode.
Budget Code	This field displays the budget code associated with the commercial transaction. If the Global, Budget Decrementation Mode was selected, this element is mandatory as it also is a reconciliation criterion.
Third Party	This field enables you to select the third party associated with the transaction.

Click the button to change the direction of the rate expression for the values of the Rate area (budget exchange rate, opportunity exchange rate). The displayed values correspond to the direction of countervalue currency against main currency, but the direction of the transaction does not change.

Click again the button to display the values with the direction of the transaction.

4. Click on the User Fields tab.

This tab enables you to define additional information on the transaction in a small text.

5. In the first field, enter the notes that you want to include in the ledger.
6. In the Reference field, enter the external reference number for the commercial transaction if any. This number is also a search and selection criterion.
7. Click OK to validate the creation or Cancel to cancel it.

To access the creation page for filters from the management page of Commercial Transactions, click the Actions dropdown menu in the filters toolbar, and select the Add option.

The creation page for filters is displayed.

This page enables the definition of unique identification information for the filter.

1. Enter a code and a description for the filter in the Code and Description fields.
2. If you want this filter to be applied by default when you access the management page of Forward Exchange Transactions, enable the Template Default Filter option.
3. If you want this filter to be only accessible by yourself, select the Private option.
4. You may add a comment in the Text area.
5. Click the Configure button to set up the filter settings.

The configuration page for filter settings is displayed.

If you want to copy the settings of an existing filter, click the Copy From button in the action bar. Click here for more information.

The filter settings are all optional: complete the ones for which you want to apply filtering criteria.

The General tab enables you to specify a filtering process on different elements: transaction date, delivery date, company, currency, direction and type, budget code, third party, bank account, flow type.

6. In the Period area, if you want to specify a filtering process on the transaction date, go through the following process.

1. Enable the option TRX Date.

The From and To fields of the area are enabled.

2. In these fields, specify the start and end date of the period, between which must fall the transaction date to display, by going through the following process:

• In the entry field, select the value to modify and enter a date with the format dd.mm.yyyy.

- or -

• Click the button to display the calendar.

A contextual window displays the calendar.

View Calendar

Use the arrows and to select the month, year and day.

- or -

To set the start date to today's date, click the button Today.

7. To specify a filtering process on the delivery date, enable the Delivery Date option, then go through the same process as above, to define the start and end dates of the period, between which must fall the delivery date for the commercial transactions to display.

8. In the General area, to filter on one of the following elements, use the button as explained previously:

Field	Description
Company	Company associated with the commercial transaction
Currency	Main currency of the commercial transaction
Transaction	Transaction Type
Budget Code	Budget type of the transaction
Third Party	A third organization affected by the transaction
Account	Bank account affected by the flow
Flow Code	Cash flow type

9. In the Receipt/Disbursement dropdown list, select a filtering criterion for the direction of the transaction:

• Export to select receipts only,
• Import to select disbursements only,
• Export Receipt and Import Disbursement to disable any filter on the transaction direction.

10. Click on the Advanced tab.

This tab enables you to define the filtering criteria on commercial transaction numbers, reference numbers, link numbers, statuses and origins of commercial transactions.

11. In the Number field of the Transaction area, enter a range of order numbers for the commercial transaction.

12. In the Reference field, enter the external reference number for the transaction.
13. In the Link field, enter a range of link numbers for commercial transactions.
14. In the Status area, select the option:

• Opened to select the non-settled transactions only,
• Updated to select the partially updated commercial transactions only,
• Closed to select the settled transactions only.

15. In the Source area, select the option:

• Imported to select only the transactions created by file import,
• Manual to select the transactions created manually,

16. Click the following buttons, as needed:

• OK to validate the setup and go back to the management page for Commercial Transactions,
• Cancel to go back to the management page for Commercial Transactions without saving this setup.

For more information on the application, modification and deletion of filters, see topic Filters.

The conversion page for amounts is displayed when you click the Conversion button located in the Characterics tab in the detailed page of a commercial transaction.

The transaction amount expressed in the transaction currency is displayed in the Amount field.

The Rate field shows the exchange rate of the bank account currency against the transaction currency. The currency pair is indicated before the value of the exchange rate.

The bank account currency is displayed in the Countervalue field.

The transaction currency is displayed in the Amount field.

Enter the value of the exchange rate for this currency pair in the Rate field.

The countervalue amount is automatically calculated and displayed in the Countervalue field.

Click OK to validate this calculation.

The detailed page of the commercial transaction is redisplayed with the calculated countervalue amount.